UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TBWQ6Uyt0ALFwy4hfV/EmcFlP6IFw2RVBZzCz9Stbc8=' 
WHERE 
  key_id = '5e593e4359fc0f83f3ce969c083ad9ff9504004545a7524f8b24cf9889b9ea18' 
  AND (
    token = 'TBWQ6Uyt0ALFwy4hfV/EmcFlP6IFw2RVBZzCz9Stbc8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044