UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCK7/9s9H0X0xEqkyFeRMgvMz7CFuSMOAE32I2YdejU='
WHERE
key_id = 'a443501db4bf51600c2cdfcb8710ee6a0f6bfa15f60161be5fa3a1ca791e4fba'
AND (
token = 'QCK7/9s9H0X0xEqkyFeRMgvMz7CFuSMOAE32I2YdejU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)