UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/TZfBqdsRt8kmTgr9FrTjlLnW9RNaom5/J/iP458wvc='
WHERE
key_id = '1e2cb4d5ed8abf167f8a9eaed51df709f06671c87f177de70b1678ceec48212b'
AND (
token = '/TZfBqdsRt8kmTgr9FrTjlLnW9RNaom5/J/iP458wvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)