UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0bIB+I2fypW5mKBr80nBdtr4CNpRen7DCEEZ3Mdirs='
WHERE
key_id = 'ca4831f9760914997b2434195a2b9adffc43ae986d32d73762404870db147be9'
AND (
token = 'D0bIB+I2fypW5mKBr80nBdtr4CNpRen7DCEEZ3Mdirs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)