UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BzGJKXOUXc7Ek96fwJSzc6V48N59rcpGN5yW7YqiEgU='
WHERE
key_id = 'a033ae6edd94b12ea52d7ffe796edf7ff3f5b58e3143feeb5a5582bed537be69'
AND (
token = 'BzGJKXOUXc7Ek96fwJSzc6V48N59rcpGN5yW7YqiEgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)