UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QcPb5zRpONqFDpwkN9akmdq3Ie7fyDsA/Eb2PJUOgWM=' 
WHERE 
  key_id = '4276d257fba4fbae5a7eb1891b7f5b43e27b8c0b5f201a2cd1f77b70f488ebc3' 
  AND (
    token = 'QcPb5zRpONqFDpwkN9akmdq3Ie7fyDsA/Eb2PJUOgWM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00012