UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AJNXhJ5GORpPy5BOULeN6y9pS2IE4LhjGMpRrbbXrno='
WHERE
key_id = 'd10ab85a1b65c9a2fc677d3f05653f505512b62e2b5124186cbed18187f797c7'
AND (
token = 'AJNXhJ5GORpPy5BOULeN6y9pS2IE4LhjGMpRrbbXrno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)