UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'By5J01VToAgQ78fUcD8BIfRiv7PpIw5j/KrU77tp12s='
WHERE
key_id = 'b9a9abe6ffe2ff49769729bbdcb62584be3190d16fd94e09a6c182315c70dc80'
AND (
token = 'By5J01VToAgQ78fUcD8BIfRiv7PpIw5j/KrU77tp12s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)