UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zOphtlpKNa8ahd24I0bTkvKLD59tvHx7YGxrPlImcA='
WHERE
key_id = '29db227c2b11abc596a19792ca0d674902c1f75552bcc974dde14fc192af545c'
AND (
token = '6zOphtlpKNa8ahd24I0bTkvKLD59tvHx7YGxrPlImcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)