UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNT8GqpGOlCBHBmWISVJYgiKkPxHpp7VJc5cruWmWOE='
WHERE
key_id = '5bcb6bab39daed3b001845da8b54c60ac45ce7a5a7a6a2db74b87a53a4eb59c6'
AND (
token = 'nNT8GqpGOlCBHBmWISVJYgiKkPxHpp7VJc5cruWmWOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)