UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oYNBhW3iQLayqDQUx5rIjElXZHF+UYgyUA/EPBqDUfY='
WHERE
key_id = 'b83a20ae3a5782b0d694fc1c58517cf8e73b6ce09bab57df029542e919199c6a'
AND (
token = 'oYNBhW3iQLayqDQUx5rIjElXZHF+UYgyUA/EPBqDUfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)