UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBsZxxUQxJ0g8DDfJkLjDQ5O1+OJDxCPS41eIksX/S8='
WHERE
key_id = '5122ba7d2274e8050a731d4308b1aa14d056e28435d0217efe6b412c06c8c27d'
AND (
token = 'XBsZxxUQxJ0g8DDfJkLjDQ5O1+OJDxCPS41eIksX/S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)