UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HkdLKxYkNj8zmfXqMhFyeQVt6FUcOyxfoR7f5MWozzs='
WHERE
key_id = '1fb46fe29a6bc8de40fe9760a7ce10e593ae96fe2f935995896577edfaa67831'
AND (
token = 'HkdLKxYkNj8zmfXqMhFyeQVt6FUcOyxfoR7f5MWozzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)