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