UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9CKIvdJb3UFTRtoOb4P9lGDiBzMd+xBCFZjf8KobKo='
WHERE
key_id = 'b1b2c704100f266b83818d966ef133c271f56496cfe6bd37a9da403ea5295cc9'
AND (
token = 'p9CKIvdJb3UFTRtoOb4P9lGDiBzMd+xBCFZjf8KobKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)