UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Ke05ro1JdSAPR3+9LptkXsuPaffjP97xNbSRQKAGs8='
WHERE
key_id = 'cfe8fd2a0fc7d291b04892c7a95d7a57f5a7b6faaded775213d99b8fce228e14'
AND (
token = '7Ke05ro1JdSAPR3+9LptkXsuPaffjP97xNbSRQKAGs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)