UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UxCBgbSEguBc5ZF91vtYIXz10V2bli1ntE2X4htGsc='
WHERE
key_id = 'bd88d4d224342bf022eded44575394c6c6ec2cada9b4d2ed376dd365dd69a093'
AND (
token = '/UxCBgbSEguBc5ZF91vtYIXz10V2bli1ntE2X4htGsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)