UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HKWl1cYoOS2apHv+WJOiZhrSdKk8gtt9k30UfSXjlKQ='
WHERE
key_id = 'eb0580a0d104ff90bd30e25492ebf06711d427ec7b58530d87de7ef8765433ae'
AND (
token = 'HKWl1cYoOS2apHv+WJOiZhrSdKk8gtt9k30UfSXjlKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)