UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bny6AIjJTDLyWUENPaxyngDcaOb0yj5zV0mIHyBoiHg='
WHERE
key_id = '77f69c0b3896daf6921202a9650705a37dac62986e8a93c9bc01e8d942297077'
AND (
token = 'Bny6AIjJTDLyWUENPaxyngDcaOb0yj5zV0mIHyBoiHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)