UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fVhShgwBtAGSxDmDitUJ3YLpjw4eLPE2pnynniMfT8w='
WHERE
key_id = '6955114f023cf4cde2bbe15291dbaeb9a33f172b0c433ac6bf4827b9fa2e5823'
AND (
token = 'fVhShgwBtAGSxDmDitUJ3YLpjw4eLPE2pnynniMfT8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)