UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vNH1LuQs3jDEQqI/PqF9cy5rh34q+5hEkrO9A8JUJgo='
WHERE
key_id = 'a0004f958a3f99e8d25249a5d0a8b1857b65bf11e7df0ad3989fa23aedc58fbb'
AND (
token = 'vNH1LuQs3jDEQqI/PqF9cy5rh34q+5hEkrO9A8JUJgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)