UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VYo/gcZlgSTcGVdGSV7ZxPP6X1Yosmg1aAw3aTHweg='
WHERE
key_id = '29ed80eba2638e9b2e99320c18146d61964acf594de4fcede0b34708f721efef'
AND (
token = '3VYo/gcZlgSTcGVdGSV7ZxPP6X1Yosmg1aAw3aTHweg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)