UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hp3cy4tOUfRc6xWER3T03EWULEvq1gjgeAESOvZ2aDA='
WHERE
key_id = '7b05c1750601e2c87995a68faf1f7f627f0342d18870ba418f3a595baa9cd28b'
AND (
token = 'hp3cy4tOUfRc6xWER3T03EWULEvq1gjgeAESOvZ2aDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)