UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tB11N1vvFeg0zcQt83vhvlBV+efPoCsQ7K42Kmi6ZUs='
WHERE
key_id = '1b9e75001976e4c965d5a5caa1589ec3cebc0be5d0262bb0067b25ff3fdfd88a'
AND (
token = 'tB11N1vvFeg0zcQt83vhvlBV+efPoCsQ7K42Kmi6ZUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)