UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rZ8V4XLtjTqoofBqmr245OA5kdCMIowwDv46zwt6TA='
WHERE
key_id = '3ffce3d2620367f94a26ee9bbf1433580a3fcb5a9d94a15ec11e1d334ab91f7a'
AND (
token = '9rZ8V4XLtjTqoofBqmr245OA5kdCMIowwDv46zwt6TA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)