UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIbYW7jnnCbzHcbm3SjYJXEP0WVI7j0ZAoQ/eZb1W7w='
WHERE
key_id = 'e4bd86788ae25055993da989887fbf8bf1a3245c8f0af50f7e031e8d52e57568'
AND (
token = 'sIbYW7jnnCbzHcbm3SjYJXEP0WVI7j0ZAoQ/eZb1W7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)