UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnqfEI4+vC5Cwwl4HN9SLZgsNUso50L5C441apJ7wJs='
WHERE
key_id = 'd0a7d3e2d7e55ed27a43a84a7e7ae0ff3b517d2fb49fb37aad01361592472f3b'
AND (
token = 'qnqfEI4+vC5Cwwl4HN9SLZgsNUso50L5C441apJ7wJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)