UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6MIOt6NvKW0C0LQfp/J3qkCV6FKj1QMUYPfGBpU+EA0='
WHERE
key_id = '8e3ada38282f6dec281d04b8cc6de4cb0dbe6e62a7f82007ea442a8f0b4c6c68'
AND (
token = '6MIOt6NvKW0C0LQfp/J3qkCV6FKj1QMUYPfGBpU+EA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)