UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AP9y3Cm+HW93C9PIXtCi9oeApae2Cy1i67y4NLNQMg4='
WHERE
key_id = 'd02d1e1648622b55a3cc47d17e457b875952901488581e2b54d3ddbe7b0e9cdf'
AND (
token = 'AP9y3Cm+HW93C9PIXtCi9oeApae2Cy1i67y4NLNQMg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)