UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C/OFwbGccEnP1aI71oGlO11mgylyDMLDSriNIIRVelM='
WHERE
key_id = '165947e6f4f1b55a2b082a622a7657d32b1bd703f363f3ae25b8876cb298e372'
AND (
token = 'C/OFwbGccEnP1aI71oGlO11mgylyDMLDSriNIIRVelM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)