UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ln4C7/2tZ36lo5AUjNykO/oSUd0sfvw8uwEOShXY8GM='
WHERE
key_id = '479efc5eae97e1be5cf4ed4827ff8afc0386a33115f4c07c3935a9573668fdf8'
AND (
token = 'ln4C7/2tZ36lo5AUjNykO/oSUd0sfvw8uwEOShXY8GM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)