UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NjaAzTcVjrU811TgPvNNyf1mrGqTuLQkGDWbBZ6qnlk=' 
WHERE 
  key_id = '10cdb585ad01af68c0532f302919948cfa3b017a0f7b4522f4d67cdcfb42e918' 
  AND (
    token = 'NjaAzTcVjrU811TgPvNNyf1mrGqTuLQkGDWbBZ6qnlk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022