UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q8q+o850YCWDFg0dP1Vv5k6+3fS2L/hR0ho8TS05WTA='
WHERE
key_id = 'c1d7262012886edae78d6741c264e48f49ab82a9b56020458f93c7057a772f5d'
AND (
token = 'Q8q+o850YCWDFg0dP1Vv5k6+3fS2L/hR0ho8TS05WTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)