UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9COJAx1z45lifPljiDQIe2OWdJT8c6yqz59EDPbue0E='
WHERE
key_id = '99c71bc355ab78152e4eed02b19a8c3a93b9e11ef785db1453d8e9bef6095924'
AND (
token = '9COJAx1z45lifPljiDQIe2OWdJT8c6yqz59EDPbue0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)