UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pN2z34/OwENf8q5ylfy3P/QQy2Is2wu1bi+L8IwdcIs='
WHERE
key_id = 'beb0e46b5ce238cdae05339baf8cd41682d63657a9bf155cdee3f0789ffe8d94'
AND (
token = 'pN2z34/OwENf8q5ylfy3P/QQy2Is2wu1bi+L8IwdcIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)