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